"""
@Time ： 2022/12/5 10:23
@Auth ： 陈杰 200320501042
@E-mail : 1612845322@qq.com
"""
from pymysql import *
conn = connect(host="localhost", port=3306, user='root', password="cj2001..",db="bookstore", charset='utf8')

sql ='''
delete from books where 编号 = 2
'''
cursor = conn.cursor()
cursor.execute(sql)
cursor.close()
conn.commit()
conn.close()
print("删除记录成功")